Forum: SQL & PL/SQL «»
Posted on: Thu, 25 November 2004 20:28 «»
By:Shankar Lakkaraju How to write the update command ?
…Experts,
I have two tables - table1 & table2
Have one date field in table1 - table1.date1
In table2, I have an integravalue - table2.intVal(units:days)
I need to update table1 with ...
table1.date1 = table1.date1 - table2.intVal
I have a valid join…